home *** CD-ROM | disk | FTP | other *** search
/ TPUG - Toronto PET Users Group / TPUG Users Group CD / TPUG Users Group CD.iso / AMIGA / AMICUS / AMICUS11.ADF / Analyze Templates / Sales.sht (.txt) < prev    next >
The Works! Spreadsheet  |  1986-08-05  |  3KB  |  67 lines
  1. 'salesAna3.0.sam.sht
  2. 'AmiSoft!                   
  3. @TODAY
  4. ' *Sales Analysis*
  5. ^Cost of 
  6. ^Fixed
  7. ^Total
  8. ^Store
  9. ^Code
  10. ^Sales
  11. 'Goods sold
  12. ^Expenses
  13. ^Expenses
  14. ^Profit
  15.     'Wichita
  16. +D6+E6
  17. +C6-F6
  18. 'Kansas City
  19. +D7+E7
  20. +C7-F7
  21. 'Denver
  22. +D8+E8
  23. +C8-F8
  24. 'Dallas
  25. +D9+E9
  26. +C9-F9
  27. 'total
  28. @SUM(C6..C9)
  29. @SUM(D6..D9)
  30. @SUM(E6..E9)
  31. @SUM(F6..F9)
  32. @SUM(G6..G9)
  33. '=============
  34. '=============
  35. '=============
  36. '=============
  37. '=============
  38. '=============
  39. '=============
  40. $'Income projection for sales change
  41.     'Wichita
  42. +C6*(1+$E$13)
  43. H+D6*(1+$E$13)
  44. +D15+E15
  45. 3334+C15-F15
  46. 'Kansas City
  47. {+C7*(1+$E$13)
  48. +D7*(1+$E$13)
  49. {+D16+E16
  50. +C16-F16
  51. 'Denver
  52. +C8*(1+$E$13)
  53. G[3334+D8*(1+$E$13)
  54. +D17+E17
  55. \(+C17-F17
  56. 'Dallas
  57. +C9*(1+$E$13)
  58. \*+D9*(1+$E$13)
  59. +D18+E18
  60. +C18-F18
  61. 'Total
  62. @SUM(C18..C15)
  63. ]@SUM(D18..D15)
  64. @SUM(E15..E18)
  65. ]@SUM(F15..F18)
  66. \*@SUM(G15..G18)
  67.